Creating Object Relationships Using Federation IDs

If the "source" property contains a federation GUID instead of a user label, then the source of the relationship is loaded by the aid of the federation GUID instead of user label and EC class name.

Data

Tag	Class	UserLabel	LongDescription	FederationGuid
FQIT-11-01	MiscEquipment	ACPPEQUIPMENT	NULL	584b2150-8c78-4835-aaec-f211c2419ad6
11IA08	Valve	ACPPPIPEINLINEASSET	Ball Valve, Long Pattern,800 LB, FPT, ASME B16.10	f792f98a-204c-4897-ab71-5c88d09f3db1
T-1130	Tank	ACPPEQUIPMENT	NULL	9d0bb946-efab-4014-be15-a2aeba986c36

Configuration

{
  "id": 5,
  "name": "mapping 5",
  "importType": "smartExcel",
  
  "classKey": "Class",
  "eCQuery": "Select acad.tag, acad.class, comp.userlabel, acad.longDescription, comp.federationGuid FROM nwddynamic.Autocad acad JOIN nwddynamic.nwdcomponent comp ON acad.element.id = comp.EcInstanceId WHERE Not acad.Tag is NULL AND Not acad.Tag LIKE '%?%'",
"relationshipsColMap": [{
	"source": "FederationGUID",
	"relationship": "StagingAreaPhysicalElementFulfillsFunction",
	"target": "EcClassId"
 }
  "data": [
    {
      "sourceClass": "Valve",
      "targetClass": "CONTROL_VALVE",
      "mapping": [
        {
          "source": "Tag",
          "target": "UserLabel"
        },
        {
          "source": "LongDescription",
          "target": "DESCRIPTION"
        }
      ]
    }
  ],